IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'RecommendationGetByID')
	BEGIN
		DROP  Procedure  RecommendationGetByID
	END

GO

CREATE Procedure RecommendationGetByID
(
	@RecommendationID int
)
AS


SELECT RecommendationID
	, CompanyID
	, RatingTypeID
	, RecommendationDate
	, Rating
	, Price
FROM Recommendations
WHERE RecommendationID = @RecommendationID